package com.sky.mapper;

import com.sky.entity.SetmealDish;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface SetmealDishMapper {
    /**
     * 根据菜品id查询对应的套餐id
     *
     * @param dishIds
     * @return
     */
//    select setmeal_id from setmeal_dish where dish_id in (1,2,3,4)
    List<Long> getSetmealIdsByDishIds(List<Long> dishIds);

//    @Options(useGeneratedKeys = true,keyProperty = "id")
//    @Insert("insert into setmeal_dish (setmeal_id,dish_id,name,price,copies) " +
//            "values (#{setmealId},#{dishId},#{name},#{price},#{copies})")

    /**
     * 新增关联
     * @param setmealDishes
     */
    void addSetmealDish(List<SetmealDish> setmealDishes);

    /**
     * 删除
     */

    void deleteSetmealDish(List<Long> dishIds);

    /**
     * 查询关联表对象集合
     * @param
     * @return
     */
    @Select("select * from setmeal_dish where setmeal_id =#{setmealId}")
    List<SetmealDish> getByDishIds(Long setmealId);
}
